package com.woniu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniu.pojo.Magnet;
import com.woniu.pojo.Space;
import com.woniu.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface GetSpaceStatusMapper extends BaseMapper<Space> {
    @Select("select * from t_magnet where id = #{magnetId}")
    Magnet selectMagnetById(Long magnetId);

    @Select("select r.name from t_space s ,t_road r where s.road_id = r.id and s.id = #{spaceId}")
    String selectRoadBySpaceId(Long spaceId);
    @Select("select i.uri from rl_order_image r,t_image i where r.order_id = #{orderId} and r.image_id = i.id")
    List<String> selectImageListByOrderId(Long orderId);
}
